Tabela Accomodation

Definicja tabeli Accomodation

Name

Accomodation

Code

Accomodation

Comment

lista kwaterowan pacjenta dla wykonanego swiadczenia


Lista kolumn tabeli Accomodation

Name

Code

AccomodationID

AccomodationID

EventID

EventID

PerfServiceID

PerfServiceID

AccomodationCode

AccomodationCode

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna AccomodationID tabeli Accomodation

Definicja kolumny AccomodationID tabeli Accomodation

Name

AccomodationID

Code

AccomodationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli Accomodation

Definicja kolumny EventID tabeli Accomodation

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID powiazanego pobytu


Kolumna PerfServiceID tabeli Accomodation

Definicja kolumny PerfServiceID tabeli Accomodation

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID powiazanej wykonanej uslug


Kolumna AccomodationCode tabeli Accomodation

Definicja kolumny AccomodationCode tabeli Accomodation

Name

AccomodationCode

Code

AccomodationCode

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

kod Miejsca zakwaterowania


Kolumna StartDT tabeli Accomodation

Definicja kolumny StartDT tabeli Accomodation

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

data rozpoczecia zakwaterowania


Kolumna StopDT tabeli Accomodation

Definicja kolumny StopDT tabeli Accomodation

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

Yes

Comment

data zakonczenia zakwaterowania


Kolumna Active tabeli Accomodation

Definicja kolumny Active tabeli Accomodation

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Lista kluczy tabeli Accomodation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Accomodation

Definicja klucza Identifier_1 tabeli Accomodation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment